{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["README","Lists"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"README","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[3,4,3,5],[9,8,10,13],[12,7,17,7],[7,1,8,2],[9,1,9,2],[8,4,8,5],[9,4,9,5],[3,1,4,2]]}
[]
[null,"Randomised Patient Record Access Report"]
[null,null,null,null,null,"for Vision 3",null,"NOTE:"]
[null,"Select Quick Date period",null,null,"Search on Specific Date Range",null,null,"Excel 2010 - Please \"Enable Content\" if a security Warning is displayed"]
[null,null,null,null,"FROM","BEFORE"]
[null,null,null,null,"2018-04-01","2018-04-30",null,"Excel 2007 - Click the Options button and enable both Macros and Data Connection"]
[null,null,null,null,null,null,null,"Excel 2003 - Not supported"]
[null,"Enter max number of patients\nto show in final report",null,null,"Active Patients = Applied and Permanent"]
[null,null,null,null,"Registration Status",null,null,"Current Version: 1.0"]
[null,30,null,null,"ACTIVE PATIENTS",null,null,"Last updated: 04/05/2018"]
[]
[null,null,null,null,null,null,null,"Disclaimer"]
[null,null,null,null,null,null,null,"In using this Microsoft Excel report you hereby acknowledge that the software cannot be guaranteed error free and may also be subject to how data is being recorded by your practice, and further acknowledge that the existence of any such errors shall not make Vision responsible for any actions you carry out based on these results."]
[]
[null,"This report will show two sets of data:"]
[null,"     • Consultations recorded in the date range"]
[null,"     • Patient record accessed in the date range (Event Log)"]
[null,"It will collect patients using the above methods"]
[null,"     1. Select the latest date for each patient"]
[null,"     2. Randomise the list of patients"]
[null,"     3. Remove all patients after to the designated number (shown above B10)"]
[null,"     4. Re-sort the patient identifiers"]
[]
[null,"Input Operator is the staff member that actually entered the data"]
[]
[null,"To import patients back into Vision, use the \"Patient Group Import App\""]
[null,"1. Copy the PAT_ID column into a new workbook (Ctrl+N)"]
[null,"2. Save this workbook as a CSV file"]
[null,"3. Click the link for instructions on how to use the App:"]

{"sheet":"Lists","index":1,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["ACTIVE PATIENTS","REG000"]
["Applied","REG001"]
["Permanent","REG002"]
["Temporary Resident < 16 days","REG003"]
["Temporary Resident 16 days to 3 months","REG004"]
["Transferred Out","REG005"]
["Immediately Necessary Treatment","REG006"]
["Emergency Treatment","REG007"]
["Child Health Surveillance","REG008"]
["Contraception","REG009"]
["Maternity","REG010"]
["Minor Surgery","REG011"]
["Private","REG012"]
["Referred","REG013"]
["Walk in Centre","REG014"]
["GP with Special Interest","REG015"]
["Minor Injury Clinic","REG016"]
["HMP Inmate","REG017"]
["Visitor (EC111)","REG018"]
["INCLUDE ALL","NONE"]